select abs.codabs, poste.libposte, abs.matricule, sal.libressource1, sal.libressource2, abs.datdeb, abs.datfin 
from tbabsenc abs 
inner join rcressource sal on abs.matricule = sal.matricule 
inner join postpla post on post.matricule = abs.matricule 
inner join poste poste on poste.codposte = post.codposte